import csv
import pandas as pd

data = pd.read_excel("../completion/datas/completed2.xlsx")  # type: pd.DataFrame
location = pd.read_excel("../location7.xlsx")  # type: pd.DataFrame
print(data.values.shape)
print(location.values.shape)
dataV = data.values
locationV = location.values
f = open('formatData7.csv', 'w',newline='')
writer = csv.writer(f)
writer.writerow(list(data.columns)+list(location.columns[1:]))
for i in range(dataV.shape[0]):
    writer.writerow(list(dataV[i]) + list(locationV[i][1:]))
f.close()
